Tabela BenefitPlanContract

Definicja tabeli BenefitPlanContract

Name

BenefitPlanContract

Code

BenefitPlanContract

Comment

PL: Przynaleznosc benefit planu do kontraktu. Kazdy bf moze przynalezec do kontraktu wiecej niz raz, bo z róznymi atrybutami. Polaczenie benefitplanu z umowa
EN: Link between contract and benefitplan


Lista kolumn tabeli BenefitPlanContract

Name

Code

BenefitPlanContractID

BenefitPlanContractID

BenefitPlanID

BenefitPlanID

BPPackageKindID

BPPackageKindID

InvoiceChangeRuleID

InvoiceChangeRuleID

CardCreationRules

CardCreationRules

ContractID

ContractID

BenefitPlanTypeID

BenefitPlanTypeID

BeneficiaryStatusID

BeneficiaryStatusID

PriceListID

PriceListID

FinanceType

FinanceType

StartDT

StartDT

StopDT

StopDT

Static

Static

OpenBeneficiaryList

OpenBeneficiaryList

NameInContract

NameInContract

JoinField

JoinField

NumberOf

NumberOf

OPK

OPK

PatientPartPerc

PatientPartPerc

DiscountPerc

DiscountPerc

EregistrationVisible

EregistrationVisible


Kolumna BenefitPlanContractID tabeli BenefitPlanContract

Definicja kolumny BenefitPlanContractID tabeli BenefitPlanContract

Name

BenefitPlanContractID

Code

BenefitPlanContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BenefitPlanID tabeli BenefitPlanContract

Definicja kolumny BenefitPlanID tabeli BenefitPlanContract

Name

BenefitPlanID

Code

BenefitPlanID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BPPackageKindID tabeli BenefitPlanContract

Definicja kolumny BPPackageKindID tabeli BenefitPlanContract

Name

BPPackageKindID

Code

BPPackageKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InvoiceChangeRuleID tabeli BenefitPlanContract

Definicja kolumny InvoiceChangeRuleID tabeli BenefitPlanContract

Name

InvoiceChangeRuleID

Code

InvoiceChangeRuleID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CardCreationRules tabeli BenefitPlanContract

Definicja kolumny CardCreationRules tabeli BenefitPlanContract

Name

CardCreationRules

Code

CardCreationRules

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractID tabeli BenefitPlanContract

Definicja kolumny ContractID tabeli BenefitPlanContract

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BenefitPlanTypeID tabeli BenefitPlanContract

Definicja kolumny BenefitPlanTypeID tabeli BenefitPlanContract

Name

BenefitPlanTypeID

Code

BenefitPlanTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BeneficiaryStatusID tabeli BenefitPlanContract

Definicja kolumny BeneficiaryStatusID tabeli BenefitPlanContract

Name

BeneficiaryStatusID

Code

BeneficiaryStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PriceListID tabeli BenefitPlanContract

Definicja kolumny PriceListID tabeli BenefitPlanContract

Name

PriceListID

Code

PriceListID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FinanceType tabeli BenefitPlanContract

Definicja kolumny FinanceType tabeli BenefitPlanContract

Name

FinanceType

Code

FinanceType

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli BenefitPlanContract

Definicja kolumny StartDT tabeli BenefitPlanContract

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli BenefitPlanContract

Definicja kolumny StopDT tabeli BenefitPlanContract

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Static tabeli BenefitPlanContract

Definicja kolumny Static tabeli BenefitPlanContract

Name

Static

Code

Static

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna OpenBeneficiaryList tabeli BenefitPlanContract

Definicja kolumny OpenBeneficiaryList tabeli BenefitPlanContract

Name

OpenBeneficiaryList

Code

OpenBeneficiaryList

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna NameInContract tabeli BenefitPlanContract

Definicja kolumny NameInContract tabeli BenefitPlanContract

Name

NameInContract

Code

NameInContract

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna JoinField tabeli BenefitPlanContract

Definicja kolumny JoinField tabeli BenefitPlanContract

Name

JoinField

Code

JoinField

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna NumberOf tabeli BenefitPlanContract

Definicja kolumny NumberOf tabeli BenefitPlanContract

Name

NumberOf

Code

NumberOf

Data Type

NUMBER(5)

Mandatory

No

Comment

Kolumna oznacza maksymalna liczbe osób, jaka moze byc przypisana do benefitplanu


Kolumna OPK tabeli BenefitPlanContract

Definicja kolumny OPK tabeli BenefitPlanContract

Name

OPK

Code

OPK

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Kod analityczny okreslajacy osrodek kosztów, na który kwalifikowane sa uslugi wykonane w ramach tego benefitplanu.


Kolumna PatientPartPerc tabeli BenefitPlanContract

Definicja kolumny PatientPartPerc tabeli BenefitPlanContract

Name

PatientPartPerc

Code

PatientPartPerc

Data Type

FLOAT

Mandatory

No

Comment

Kolumna przechowuje informacje o procentowym udziale pacjenta w cene (dla FinanceType = 1 lub 2)


Kolumna DiscountPerc tabeli BenefitPlanContract

Definicja kolumny DiscountPerc tabeli BenefitPlanContract

Name

DiscountPerc

Code

DiscountPerc

Data Type

FLOAT

Mandatory

No

Comment

Informacjao rabacie dla FinanceType = 1 lub 2


Kolumna EregistrationVisible tabeli BenefitPlanContract

Definicja kolumny EregistrationVisible tabeli BenefitPlanContract

Name

EregistrationVisible

Code

EregistrationVisible

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Kolumna okresla czy dany benefitplan w umowie jest widoczny w eRejestracji czy nie. Domyslnie jest widoczny. Widocznosc bedzie wylaczana w nielicznychprzypadkach


Lista kluczy tabeli BenefitPlanContract

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli BenefitPlanContract

Definicja klucza Identifier_1 tabeli BenefitPlanContract

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment